CREATE TABLE Department	(
	deptName	VARCHAR2(20),
	chairPerson	VARCHAR2(6),
	CONSTRAINT Department_deptName_pk PRIMARY KEY(deptName),
	CONSTRAINT Department_facId_fk FOREIGN KEY(chairperson) REFERENCES Faculty (facId));


alter table Department disable constraint Department_facId_fk;


insert into Department(deptName) values('Art');
insert into Department(deptName) values('csc');
insert into Department(deptName) values('Math');
insert into Department(deptName) values('History');

update department set chairperson='F101' where deptName='Art';
update department set chairperson='F221' where deptName='CSC';
update department set chairperson='F110' where deptName='Math';
update department set chairperson='F115' where deptName='History';

ALTER TABLE DEPARTMENT ENABLE CONSTRAINT Department_facId_fk;

ALTER TABLE Faculty ADD CONSTRAINT Faculty_department_fk FOREIGN KEY(department) REFERENCES Department(deptName);